TYPE=VIEW
query=(select `db_iwms_new`.`tbl_unit`.`unit_code` AS `unit_code`,`db_iwms_new`.`tbl_unit`.`unit_name` AS `unit_name`,`db_iwms_new`.`tbl_unit`.`unit_note` AS `unit_note`,`db_iwms_new`.`tbl_unit`.`unit_id` AS `unit_id`,`db_iwms_new`.`tbl_unit`.`unit_status` AS `unit_status`,`db_iwms_new`.`tbl_unit`.`unit_order` AS `unit_order` from `db_iwms_new`.`tbl_unit` where (`db_iwms_new`.`tbl_unit`.`unit_status` = 1))
md5=3a03dd2acdbcb521ab467777826067e6
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-10-22 15:31:01
create-version=1
source=(select `db_iwms_new`.`tbl_unit`.`unit_code` AS `unit_code`,`db_iwms_new`.`tbl_unit`.`unit_name` AS `unit_name`,`db_iwms_new`.`tbl_unit`.`unit_note` AS `unit_note`,`db_iwms_new`.`tbl_unit`.`unit_id` AS `unit_id`,`db_iwms_new`.`tbl_unit`.`unit_status` AS `unit_status`,`db_iwms_new`.`tbl_unit`.`unit_order` AS `unit_order` from `tbl_unit` where (`db_iwms_new`.`tbl_unit`.`unit_status` = 1))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `db_iwms_new`.`tbl_unit`.`unit_code` AS `unit_code`,`db_iwms_new`.`tbl_unit`.`unit_name` AS `unit_name`,`db_iwms_new`.`tbl_unit`.`unit_note` AS `unit_note`,`db_iwms_new`.`tbl_unit`.`unit_id` AS `unit_id`,`db_iwms_new`.`tbl_unit`.`unit_status` AS `unit_status`,`db_iwms_new`.`tbl_unit`.`unit_order` AS `unit_order` from `db_iwms_new`.`tbl_unit` where (`db_iwms_new`.`tbl_unit`.`unit_status` = 1))
